package com.mybatis.firstMybatis;

import org.apache.ibatis.jdbc.SQL;

public class App3 {

	public static void main(String[] args) {

		// SQL语句构建器
		String sql = new SQL() {{
		    SELECT("P.ID, P.USERNAME, P.PASSWORD, P.FULL_NAME");
		    SELECT("P.LAST_NAME, P.CREATED_ON, P.UPDATED_ON");
		    FROM("PERSON P");
		    FROM("ACCOUNT A");
		    INNER_JOIN("DEPARTMENT D on D.ID = P.DEPARTMENT_ID");
		    INNER_JOIN("COMPANY C on D.COMPANY_ID = C.ID");
		    WHERE("P.ID = A.ID");
		    WHERE("P.FIRST_NAME like ?");
		    OR();
		    WHERE("P.LAST_NAME like ?");
		    GROUP_BY("P.ID");
		    HAVING("P.LAST_NAME like ?");
		    OR();
		    HAVING("P.FIRST_NAME like ?");
		    ORDER_BY("P.ID");
		    ORDER_BY("P.FULL_NAME");
		  }}.toString();
		
		  System.out.println(sql);
		  
	}

}
